Overview

Brought to you by YData

Dataset statistics

Number of variables	25
Number of observations	2823
Missing cells	34473
Missing cells (%)	48.8%
Total size in memory	551.5 KiB
Average record size in memory	200.0 B

Variable types

Text	17
Numeric	8

Alerts

`QUANTITYORDERED` has 1315 (46.6%) missing values	Missing
`PRICEEACH` has 1315 (46.6%) missing values	Missing
`ORDERLINENUMBER` has 1315 (46.6%) missing values	Missing
`SALES` has 1315 (46.6%) missing values	Missing
`ORDERDATE` has 1315 (46.6%) missing values	Missing
`STATUS` has 1315 (46.6%) missing values	Missing
`QTR_ID` has 1315 (46.6%) missing values	Missing
`MONTH_ID` has 1315 (46.6%) missing values	Missing
`YEAR_ID` has 1315 (46.6%) missing values	Missing
`PRODUCTLINE` has 1315 (46.6%) missing values	Missing
`MSRP` has 1315 (46.6%) missing values	Missing
`PRODUCTCODE` has 1315 (46.6%) missing values	Missing
`CUSTOMERNAME` has 1315 (46.6%) missing values	Missing
`PHONE` has 1315 (46.6%) missing values	Missing
`ADDRESSLINE1` has 1315 (46.6%) missing values	Missing
`ADDRESSLINE2` has 2684 (95.1%) missing values	Missing
`CITY` has 1315 (46.6%) missing values	Missing
`STATE` has 1784 (63.2%) missing values	Missing
`POSTALCODE` has 1377 (48.8%) missing values	Missing
`COUNTRY` has 1315 (46.6%) missing values	Missing
`TERRITORY` has 2328 (82.5%) missing values	Missing
`CONTACTLASTNAME` has 1315 (46.6%) missing values	Missing
`CONTACTFIRSTNAME` has 1315 (46.6%) missing values	Missing
`DEALSIZE` has 1315 (46.6%) missing values	Missing

Reproduction

Analysis started	2025-11-10 21:23:52.691110
Analysis finished	2025-11-10 21:23:53.883268
Duration	1.19 second
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

ORDERNUMBER
Text

Distinct	1480
Distinct (%)	52.4%
Missing	0
Missing (%)	0.0%
Memory size	22.2 KiB

Length

Max length	233
Median length	5
Mean length	92.10556146
Min length	5

Characters and Unicode

Total characters	260014
Distinct characters	76
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1321 ?
Unique (%)	46.8%

Sample

1st row	10107
2nd row	10121
3rd row	10134
4th row	10145
5th row	10159

Value	Count	Frequency (%)
555	306	2.2%
moralzarzal	259	1.8%
94	259	1.8%
channel,(91	259	1.8%
shopping	259	1.8%
44,"c	259	1.8%
and	182	1.3%
rue	153	1.1%
86",,madrid,,28034,spain,emea,freyre,diego,medium	131	0.9%
collectables	124	0.9%
Other values (2997)	11986	84.5%

Most occurring characters

Value	Count	Frequency (%)
,	33073	12.7%
0	18666	7.2%
1	13716	5.3%
2	11569	4.4%
	11402	4.4%
e	10675	4.1%
a	10166	3.9%
5	8334	3.2%
4	8331	3.2%
i	7988	3.1%
Other values (66)	126094	48.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91115	35.0%
Decimal Number	84922	32.7%
Other Punctuation	43793	16.8%
Uppercase Letter	25400	9.8%
Space Separator	11402	4.4%
Connector Punctuation	1315	0.5%
Dash Punctuation	674	0.3%
Close Punctuation	531	0.2%
Open Punctuation	531	0.2%
Math Symbol	289	0.1%
Other values (2)	42	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10675	11.7%
a	10166	11.2%
i	7988	8.8%
r	7562	8.3%
n	6616	7.3%
l	6214	6.8%
o	5725	6.3%
s	5722	6.3%
d	4385	4.8%
p	4123	4.5%
Other values (16)	21939	24.1%

Uppercase Letter

Value	Count	Frequency (%)
S	5163	20.3%
C	3386	13.3%
M	3080	12.1%
E	2525	9.9%
A	2441	9.6%
L	988	3.9%
F	947	3.7%
D	775	3.1%
P	752	3.0%
T	677	2.7%
Other values (14)	4666	18.4%

Decimal Number

Value	Count	Frequency (%)
0	18666	22.0%
1	13716	16.2%
2	11569	13.6%
5	8334	9.8%
4	8331	9.8%
3	7221	8.5%
8	4807	5.7%
6	4534	5.3%
9	4121	4.9%
7	3623	4.3%

Other Punctuation

Value	Count	Frequency (%)
,	33073	75.5%
.	3175	7.3%
"	2986	6.8%
/	2979	6.8%
:	1315	3.0%
'	174	0.4%
&	59	0.1%
¡	32	0.1%

Space Separator

Value	Count	Frequency (%)
	11402	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1315	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	674	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	531	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	531	100.0%

Math Symbol

Value	Count	Frequency (%)
+	289	100.0%

Currency Symbol

Value	Count	Frequency (%)
¤	23	100.0%

Control

Value	Count	Frequency (%)
	19	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	143499	55.2%
Latin	116515	44.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10675	9.2%
a	10166	8.7%
i	7988	6.9%
r	7562	6.5%
n	6616	5.7%
l	6214	5.3%
o	5725	4.9%
s	5722	4.9%
S	5163	4.4%
d	4385	3.8%
Other values (40)	46299	39.7%

Common

Value	Count	Frequency (%)
,	33073	23.0%
0	18666	13.0%
1	13716	9.6%
2	11569	8.1%
	11402	7.9%
5	8334	5.8%
4	8331	5.8%
3	7221	5.0%
8	4807	3.3%
6	4534	3.2%
Other values (16)	21846	15.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	259940	> 99.9%
None	74	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
,	33073	12.7%
0	18666	7.2%
1	13716	5.3%
2	11569	4.5%
	11402	4.4%
e	10675	4.1%
a	10166	3.9%
5	8334	3.2%
4	8331	3.2%
i	7988	3.1%
Other values (63)	126020	48.5%

None

Value	Count	Frequency (%)
¡	32	43.2%
¤	23	31.1%
	19	25.7%

QUANTITYORDERED
Real number (ℝ)

Missing

Distinct	56
Distinct (%)	3.7%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	35.13793103

Minimum	6
Maximum	85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	6
5-th percentile	21
Q1	27
median	35
Q3	43
95-th percentile	49
Maximum	85
Range	79
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.730179021
Coefficient of variation (CV)	0.2769138288
Kurtosis	0.2701094943
Mean	35.13793103
Median Absolute Deviation (MAD)	8
Skewness	0.3283178087
Sum	52988
Variance	94.67638377
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34	60	2.1%
48	60	2.1%
27	58	2.1%
36	57	2.0%
26	55	1.9%
31	55	1.9%
33	54	1.9%
46	52	1.8%
29	52	1.8%
25	52	1.8%
Other values (46)	953	33.8%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
6	2	0.1%
10	2	0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
85	1	< 0.1%
77	1	< 0.1%
76	2	0.1%
70	1	< 0.1%
66	1	< 0.1%

PRICEEACH
Real number (ℝ)

Missing

Distinct	633
Distinct (%)	42.0%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	83.95025862

Minimum	27.22
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	27.22
5-th percentile	42.26
Q1	69.87
median	96.7
Q3	100
95-th percentile	100
Maximum	100
Range	72.78
Interquartile range (IQR)	30.13

Descriptive statistics

Standard deviation	20.12215198
Coefficient of variation (CV)	0.2396913637
Kurtosis	-0.2399313702
Mean	83.95025862
Median Absolute Deviation (MAD)	3.3
Skewness	-0.9936937114
Sum	126596.99
Variance	404.9010001
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	708	25.1%
90.57	4	0.1%
51.93	4	0.1%
53.72	4	0.1%
33.23	4	0.1%
89.38	4	0.1%
64	4	0.1%
61.99	3	0.1%
88.63	3	0.1%
76.43	3	0.1%
Other values (623)	767	27.2%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
27.22	1	< 0.1%
28.29	1	< 0.1%
28.88	1	< 0.1%
29.54	3	0.1%
29.7	1	< 0.1%

Value	Count	Frequency (%)
100	708	25.1%
99.91	1	< 0.1%
99.66	1	< 0.1%
99.58	1	< 0.1%
99.55	2	0.1%

ORDERLINENUMBER
Real number (ℝ)

Missing

Distinct	18
Distinct (%)	1.2%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	6.429708223

Minimum	1
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	14
Maximum	18
Range	17
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.230388145
Coefficient of variation (CV)	0.6579440308
Kurtosis	-0.5547808912
Mean	6.429708223
Median Absolute Deviation (MAD)	3
Skewness	0.6049765433
Sum	9696
Variance	17.89618386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
1	165	5.8%
2	159	5.6%
3	147	5.2%
4	138	4.9%
5	127	4.5%
6	117	4.1%
7	105	3.7%
8	100	3.5%
9	86	3.0%
10	73	2.6%
Other values (8)	291	10.3%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
1	165	5.8%
2	159	5.6%
3	147	5.2%
4	138	4.9%
5	127	4.5%

Value	Count	Frequency (%)
18	6	0.2%
17	11	0.4%
16	23	0.8%
15	30	1.1%
14	46	1.6%

SALES
Real number (ℝ)

Missing

Distinct	1490
Distinct (%)	98.8%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	3568.921194

Minimum	541.14
Maximum	14082.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	541.14
5-th percentile	1263.731
Q1	2216.58
median	3194.395
Q3	4508.27
95-th percentile	7164.107
Maximum	14082.8
Range	13541.66
Interquartile range (IQR)	2291.69

Descriptive statistics

Standard deviation	1847.735232
Coefficient of variation (CV)	0.5177293449
Kurtosis	1.859279439
Mean	3568.921194
Median Absolute Deviation (MAD)	1094.285
Skewness	1.168804506
Sum	5381933.16
Variance	3414125.486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2624	2	0.1%
3451	2	0.1%
3003	2	0.1%
5464.69	2	0.1%
3734	2	0.1%
3508.8	2	0.1%
2803.2	2	0.1%
2688	2	0.1%
1459.6	2	0.1%
3789.72	2	0.1%
Other values (1480)	1488	52.7%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
541.14	1	< 0.1%
577.6	1	< 0.1%
640.05	1	< 0.1%
651.8	1	< 0.1%
717.4	1	< 0.1%

Value	Count	Frequency (%)
14082.8	1	< 0.1%
12536.5	1	< 0.1%
11623.7	1	< 0.1%
11336.7	1	< 0.1%
11279.2	1	< 0.1%

ORDERDATE
Text

Missing

Distinct	146
Distinct (%)	9.7%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	15
Median length	14
Mean length	14.01061008
Min length	13

Characters and Unicode

Total characters	21128
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.2%

Sample

1st row	2/24/2003 0:00
2nd row	5/7/2003 0:00
3rd row	7/1/2003 0:00
4th row	8/25/2003 0:00
5th row	10/10/2003 0:00

Value	Count	Frequency (%)
0:00	1508	50.0%
11/4/2004	29	1.0%
11/5/2003	28	0.9%
9/8/2004	26	0.9%
10/22/2004	26	0.9%
11/5/2004	23	0.8%
2/17/2005	22	0.7%
10/15/2004	22	0.7%
7/21/2004	20	0.7%
10/10/2003	19	0.6%
Other values (137)	1293	42.9%

Most occurring characters

Value	Count	Frequency (%)
0	7912	37.4%
/	3016	14.3%
2	2289	10.8%
1	1660	7.9%
	1508	7.1%
:	1508	7.1%
4	931	4.4%
3	845	4.0%
5	565	2.7%
8	271	1.3%
Other values (3)	623	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15096	71.5%
Other Punctuation	4524	21.4%
Space Separator	1508	7.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7912	52.4%
2	2289	15.2%
1	1660	11.0%
4	931	6.2%
3	845	5.6%
5	565	3.7%
8	271	1.8%
7	261	1.7%
9	200	1.3%
6	162	1.1%

Other Punctuation

Value	Count	Frequency (%)
/	3016	66.7%
:	1508	33.3%

Space Separator

Value	Count	Frequency (%)
	1508	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	21128	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	7912	37.4%
/	3016	14.3%
2	2289	10.8%
1	1660	7.9%
	1508	7.1%
:	1508	7.1%
4	931	4.4%
3	845	4.0%
5	565	2.7%
8	271	1.3%
Other values (3)	623	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21128	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	7912	37.4%
/	3016	14.3%
2	2289	10.8%
1	1660	7.9%
	1508	7.1%
:	1508	7.1%
4	931	4.4%
3	845	4.0%
5	565	2.7%
8	271	1.3%
Other values (3)	623	2.9%

STATUS
Text

Missing

Distinct	6
Distinct (%)	0.4%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	10
Median length	7
Mean length	7.078912467
Min length	7

Characters and Unicode

Total characters	10675
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Shipped
2nd row	Shipped
3rd row	Shipped
4th row	Shipped
5th row	Shipped

Value	Count	Frequency (%)
shipped	1399	90.0%
on	38	2.4%
hold	38	2.4%
cancelled	30	1.9%
resolved	29	1.9%
in	9	0.6%
process	9	0.6%
disputed	3	0.2%

Most occurring characters

Value	Count	Frequency (%)
p	2801	26.2%
e	1529	14.3%
d	1499	14.0%
i	1402	13.1%
S	1399	13.1%
h	1399	13.1%
l	127	1.2%
n	77	0.7%
o	76	0.7%
s	50	0.5%
Other values (14)	316	3.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9073	85.0%
Uppercase Letter	1555	14.6%
Space Separator	47	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	2801	30.9%
e	1529	16.9%
d	1499	16.5%
i	1402	15.5%
h	1399	15.4%
l	127	1.4%
n	77	0.8%
o	76	0.8%
s	50	0.6%
c	39	0.4%
Other values (5)	74	0.8%

Uppercase Letter

Value	Count	Frequency (%)
S	1399	90.0%
O	38	2.4%
H	38	2.4%
C	30	1.9%
R	29	1.9%
I	9	0.6%
P	9	0.6%
D	3	0.2%

Space Separator

Value	Count	Frequency (%)
	47	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10628	99.6%
Common	47	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
p	2801	26.4%
e	1529	14.4%
d	1499	14.1%
i	1402	13.2%
S	1399	13.2%
h	1399	13.2%
l	127	1.2%
n	77	0.7%
o	76	0.7%
s	50	0.5%
Other values (13)	269	2.5%

Common

Value	Count	Frequency (%)
	47	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
p	2801	26.2%
e	1529	14.3%
d	1499	14.0%
i	1402	13.1%
S	1399	13.1%
h	1399	13.1%
l	127	1.2%
n	77	0.7%
o	76	0.7%
s	50	0.5%
Other values (14)	316	3.0%

QTR_ID
Real number (ℝ)

Missing

Distinct	4
Distinct (%)	0.3%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.777851459

Minimum	1
Maximum	4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	4
Maximum	4
Range	3
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.176122835
Coefficient of variation (CV)	0.42339299
Kurtosis	-1.393850796
Mean	2.777851459
Median Absolute Deviation (MAD)	1
Skewness	-0.3492826553
Sum	4189
Variance	1.383264923
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
4	591	20.9%
1	321	11.4%
3	312	11.1%
2	284	10.1%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
1	321	11.4%
2	284	10.1%
3	312	11.1%
4	591	20.9%

Value	Count	Frequency (%)
4	591	20.9%
3	312	11.1%
2	284	10.1%
1	321	11.4%

MONTH_ID
Real number (ℝ)

Missing

Distinct	12
Distinct (%)	0.8%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	7.305702918

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	8
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.502588952
Coefficient of variation (CV)	0.479432163
Kurtosis	-1.289794045
Mean	7.305702918
Median Absolute Deviation (MAD)	3
Skewness	-0.3210388187
Sum	11017
Variance	12.26812937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	314	11.1%
10	173	6.1%
3	133	4.7%
5	132	4.7%
8	129	4.6%
2	111	3.9%
12	104	3.7%
7	102	3.6%
9	81	2.9%
4	80	2.8%
Other values (2)	149	5.3%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
1	77	2.7%
2	111	3.9%
3	133	4.7%
4	80	2.8%
5	132	4.7%

Value	Count	Frequency (%)
12	104	3.7%
11	314	11.1%
10	173	6.1%
9	81	2.9%
8	129	4.6%

YEAR_ID
Real number (ℝ)

Missing

Distinct	3
Distinct (%)	0.2%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	2003.801724

Minimum	2003
Maximum	2005
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	2003
5-th percentile	2003
Q1	2003
median	2004
Q3	2004
95-th percentile	2005
Maximum	2005
Range	2
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.6987122088
Coefficient of variation (CV)	0.0003486932865
Kurtosis	-0.9419750236
Mean	2003.801724
Median Absolute Deviation (MAD)	1
Skewness	0.2929233986
Sum	3021733
Variance	0.4881987507
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=3)

Value	Count	Frequency (%)
2004	713	25.3%
2003	547	19.4%
2005	248	8.8%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
2003	547	19.4%
2004	713	25.3%
2005	248	8.8%

Value	Count	Frequency (%)
2005	248	8.8%
2004	713	25.3%
2003	547	19.4%

PRODUCTLINE
Text

Missing

Distinct	7
Distinct (%)	0.5%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	16
Median length	12
Mean length	10.8938992
Min length	5

Characters and Unicode

Total characters	16428
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Motorcycles
2nd row	Motorcycles
3rd row	Motorcycles
4th row	Motorcycles
5th row	Motorcycles

Value	Count	Frequency (%)
cars	821	30.9%
classic	485	18.2%
vintage	336	12.6%
motorcycles	187	7.0%
trucks	165	6.2%
and	165	6.2%
buses	165	6.2%
planes	164	6.2%
ships	131	4.9%
trains	40	1.5%

Most occurring characters

Value	Count	Frequency (%)
s	2808	17.1%
a	2011	12.2%
C	1306	7.9%
r	1213	7.4%
	1151	7.0%
c	1024	6.2%
i	992	6.0%
e	852	5.2%
l	836	5.1%
n	705	4.3%
Other values (15)	3530	21.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12783	77.8%
Uppercase Letter	2494	15.2%
Space Separator	1151	7.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	2808	22.0%
a	2011	15.7%
r	1213	9.5%
c	1024	8.0%
i	992	7.8%
e	852	6.7%
l	836	6.5%
n	705	5.5%
t	523	4.1%
o	374	2.9%
Other values (7)	1445	11.3%

Uppercase Letter

Value	Count	Frequency (%)
C	1306	52.4%
V	336	13.5%
T	205	8.2%
M	187	7.5%
B	165	6.6%
P	164	6.6%
S	131	5.3%

Space Separator

Value	Count	Frequency (%)
	1151	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15277	93.0%
Common	1151	7.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	2808	18.4%
a	2011	13.2%
C	1306	8.5%
r	1213	7.9%
c	1024	6.7%
i	992	6.5%
e	852	5.6%
l	836	5.5%
n	705	4.6%
t	523	3.4%
Other values (14)	3007	19.7%

Common

Value	Count	Frequency (%)
	1151	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16428	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	2808	17.1%
a	2011	12.2%
C	1306	7.9%
r	1213	7.4%
	1151	7.0%
c	1024	6.2%
i	992	6.0%
e	852	5.2%
l	836	5.1%
n	705	4.3%
Other values (15)	3530	21.5%

MSRP
Real number (ℝ)

Missing

Distinct	80
Distinct (%)	5.3%
Missing	1315
Missing (%)	46.6%
Infinite	0
Infinite (%)	0.0%
Mean	101.1047745

Minimum	33
Maximum	214
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.2 KiB

Quantile statistics

Minimum	33
5-th percentile	43
Q1	68
median	99
Q3	124
95-th percentile	170
Maximum	214
Range	181
Interquartile range (IQR)	56

Descriptive statistics

Standard deviation	40.0180736
Coefficient of variation (CV)	0.3958079506
Kurtosis	-0.05987990995
Mean	101.1047745
Median Absolute Deviation (MAD)	28
Skewness	0.5918132432
Sum	152466
Variance	1601.446215
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	59	2.1%
118	58	2.1%
136	48	1.7%
62	41	1.5%
60	41	1.5%
68	40	1.4%
80	33	1.2%
86	31	1.1%
102	30	1.1%
54	30	1.1%
Other values (70)	1097	38.9%
(Missing)	1315	46.6%

Value	Count	Frequency (%)
33	13	0.5%
35	15	0.5%
37	12	0.4%
40	12	0.4%
41	13	0.5%

Value	Count	Frequency (%)
214	16	0.6%
207	16	0.6%
194	11	0.4%
193	15	0.5%
173	16	0.6%

PRODUCTCODE
Text

Missing

Distinct	109
Distinct (%)	7.2%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	9
Median length	8
Mean length	8.115384615
Min length	8

Characters and Unicode

Total characters	12238
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	S10_1678
2nd row	S10_1678
3rd row	S10_1678
4th row	S10_1678
5th row	S10_1678

Value	Count	Frequency (%)
s18_3232	21	1.4%
s12_2823	18	1.2%
s18_3320	18	1.2%
s18_2957	18	1.2%
s10_4757	18	1.2%
s24_4258	18	1.2%
s18_3136	17	1.1%
s32_1268	17	1.1%
s700_1938	17	1.1%
s12_3891	16	1.1%
Other values (99)	1330	88.2%

Most occurring characters

Value	Count	Frequency (%)
2	1691	13.8%
1	1538	12.6%
_	1508	12.3%
S	1508	12.3%
4	1067	8.7%
8	1064	8.7%
0	991	8.1%
3	900	7.4%
7	575	4.7%
9	504	4.1%
Other values (2)	892	7.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9222	75.4%
Connector Punctuation	1508	12.3%
Uppercase Letter	1508	12.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1691	18.3%
1	1538	16.7%
4	1067	11.6%
8	1064	11.5%
0	991	10.7%
3	900	9.8%
7	575	6.2%
9	504	5.5%
6	493	5.3%
5	399	4.3%

Connector Punctuation

Value	Count	Frequency (%)
_	1508	100.0%

Uppercase Letter

Value	Count	Frequency (%)
S	1508	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10730	87.7%
Latin	1508	12.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1691	15.8%
1	1538	14.3%
_	1508	14.1%
4	1067	9.9%
8	1064	9.9%
0	991	9.2%
3	900	8.4%
7	575	5.4%
9	504	4.7%
6	493	4.6%

Latin

Value	Count	Frequency (%)
S	1508	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12238	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1691	13.8%
1	1538	12.6%
_	1508	12.3%
S	1508	12.3%
4	1067	8.7%
8	1064	8.7%
0	991	8.1%
3	900	7.4%
7	575	4.7%
9	504	4.1%
Other values (2)	892	7.3%

CUSTOMERNAME
Text

Missing

Distinct	51
Distinct (%)	3.4%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	30
Median length	25
Mean length	20.55371353
Min length	10

Characters and Unicode

Total characters	30995
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Land of Toys Inc.
2nd row	Reims Collectables
3rd row	Lyon Souveniers
4th row	Toys4GrownUps.com
5th row	Corporate Gift Ideas Co.

Value	Count	Frequency (%)
mini	349	7.8%
inc	335	7.4%
gifts	304	6.8%
co	263	5.8%
ltd	230	5.1%
collectables	210	4.7%
distributors	203	4.5%
gift	174	3.9%
ideas	98	2.2%
diecast	83	1.8%
Other values (72)	2248	50.0%

Most occurring characters

Value	Count	Frequency (%)
	2989	9.6%
i	2712	8.7%
s	2345	7.6%
e	2119	6.8%
t	2092	6.7%
o	1898	6.1%
n	1668	5.4%
a	1524	4.9%
l	1383	4.5%
c	1242	4.0%
Other values (42)	11023	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22349	72.1%
Uppercase Letter	4539	14.6%
Space Separator	2989	9.6%
Other Punctuation	1054	3.4%
Decimal Number	56	0.2%
Dash Punctuation	8	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	2712	12.1%
s	2345	10.5%
e	2119	9.5%
t	2092	9.4%
o	1898	8.5%
n	1668	7.5%
a	1524	6.8%
l	1383	6.2%
c	1242	5.6%
r	1180	5.3%
Other values (15)	4186	18.7%

Uppercase Letter

Value	Count	Frequency (%)
C	819	18.0%
M	562	12.4%
G	560	12.3%
I	527	11.6%
L	382	8.4%
D	372	8.2%
S	366	8.1%
T	177	3.9%
A	146	3.2%
W	125	2.8%
Other values (11)	503	11.1%

Other Punctuation

Value	Count	Frequency (%)
.	897	85.1%
&	91	8.6%
'	66	6.3%

Space Separator

Value	Count	Frequency (%)
	2989	100.0%

Decimal Number

Value	Count	Frequency (%)
4	56	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	26888	86.7%
Common	4107	13.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	2712	10.1%
s	2345	8.7%
e	2119	7.9%
t	2092	7.8%
o	1898	7.1%
n	1668	6.2%
a	1524	5.7%
l	1383	5.1%
c	1242	4.6%
r	1180	4.4%
Other values (36)	8725	32.4%

Common

Value	Count	Frequency (%)
	2989	72.8%
.	897	21.8%
&	91	2.2%
'	66	1.6%
4	56	1.4%
-	8	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30995	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2989	9.6%
i	2712	8.7%
s	2345	7.6%
e	2119	6.8%
t	2092	6.7%
o	1898	6.1%
n	1668	5.4%
a	1524	4.9%
l	1383	4.5%
c	1242	4.0%
Other values (42)	11023	35.6%

PHONE
Text

Missing

Distinct	50
Distinct (%)	3.3%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	16
Median length	10
Mean length	10.47214854
Min length	9

Characters and Unicode

Total characters	15792
Distinct characters	16
Distinct categories	7 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2125557818
2nd row	26.47.1555
3rd row	+33 1 46 62 7555
4th row	6265557265
5th row	6505551386

Value	Count	Frequency (%)
4155551450	180	8.8%
3555	63	3.1%
6175558555	51	2.5%
2125557818	49	2.4%
2125557413	48	2.3%
035-640555	48	2.3%
6505551386	41	2.0%
26.47.1555	41	2.0%
4085553659	40	1.9%
6562-9555	40	1.9%
Other values (59)	1453	70.7%

Most occurring characters

Value	Count	Frequency (%)
5	6379	40.4%
1	1362	8.6%
6	1089	6.9%
2	1063	6.7%
0	1012	6.4%
4	972	6.2%
8	811	5.1%
7	708	4.5%
3	680	4.3%
	546	3.5%
Other values (6)	1170	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14544	92.1%
Space Separator	546	3.5%
Dash Punctuation	308	2.0%
Other Punctuation	122	0.8%
Open Punctuation	95	0.6%
Close Punctuation	95	0.6%
Math Symbol	82	0.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	6379	43.9%
1	1362	9.4%
6	1089	7.5%
2	1063	7.3%
0	1012	7.0%
4	972	6.7%
8	811	5.6%
7	708	4.9%
3	680	4.7%
9	468	3.2%

Space Separator

Value	Count	Frequency (%)
	546	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	308	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	122	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	95	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	95	100.0%

Math Symbol

Value	Count	Frequency (%)
+	82	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15792	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	6379	40.4%
1	1362	8.6%
6	1089	6.9%
2	1063	6.7%
0	1012	6.4%
4	972	6.2%
8	811	5.1%
7	708	4.5%
3	680	4.3%
	546	3.5%
Other values (6)	1170	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15792	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	6379	40.4%
1	1362	8.6%
6	1089	6.9%
2	1063	6.7%
0	1012	6.4%
4	972	6.2%
8	811	5.1%
7	708	4.5%
3	680	4.3%
	546	3.5%
Other values (6)	1170	7.4%

ADDRESSLINE1
Text

Missing

Distinct	51
Distinct (%)	3.4%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	42
Median length	24
Mean length	18.48806366
Min length	11

Characters and Unicode

Total characters	27880
Distinct characters	57
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	897 Long Airport Avenue
2nd row	59 rue de l'Abbaye
3rd row	27 rue du Colonel Pierre Avia
4th row	78934 Hillside Dr.
5th row	7734 Strong St.

Value	Count	Frequency (%)
st	372	7.3%
strong	250	4.9%
5677	180	3.5%
circle	135	2.6%
furth	135	2.6%
dr	133	2.6%
rue	128	2.5%
street	126	2.5%
avenue	83	1.6%
ln	83	1.6%
Other values (105)	3476	68.1%

Most occurring characters

Value	Count	Frequency (%)
	3593	12.9%
e	1874	6.7%
t	1680	6.0%
r	1633	5.9%
n	1386	5.0%
o	1322	4.7%
i	996	3.6%
a	984	3.5%
S	975	3.5%
l	930	3.3%
Other values (47)	12507	44.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14835	53.2%
Decimal Number	5137	18.4%
Space Separator	3593	12.9%
Uppercase Letter	3346	12.0%
Other Punctuation	836	3.0%
Dash Punctuation	133	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1874	12.6%
t	1680	11.3%
r	1633	11.0%
n	1386	9.3%
o	1322	8.9%
i	996	6.7%
a	984	6.6%
l	930	6.3%
g	713	4.8%
u	563	3.8%
Other values (11)	2754	18.6%

Uppercase Letter

Value	Count	Frequency (%)
S	975	29.1%
A	308	9.2%
L	292	8.7%
C	269	8.0%
P	211	6.3%
D	183	5.5%
F	161	4.8%
V	146	4.4%
M	121	3.6%
R	107	3.2%
Other values (10)	573	17.1%

Decimal Number

Value	Count	Frequency (%)
7	874	17.0%
5	713	13.9%
4	552	10.7%
3	529	10.3%
6	507	9.9%
2	486	9.5%
8	443	8.6%
1	358	7.0%
9	353	6.9%
0	322	6.3%

Other Punctuation

Value	Count	Frequency (%)
.	695	83.1%
'	77	9.2%
?	38	4.5%
#	26	3.1%

Space Separator

Value	Count	Frequency (%)
	3593	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	133	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18181	65.2%
Common	9699	34.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1874	10.3%
t	1680	9.2%
r	1633	9.0%
n	1386	7.6%
o	1322	7.3%
i	996	5.5%
a	984	5.4%
S	975	5.4%
l	930	5.1%
g	713	3.9%
Other values (31)	5688	31.3%

Common

Value	Count	Frequency (%)
	3593	37.0%
7	874	9.0%
5	713	7.4%
.	695	7.2%
4	552	5.7%
3	529	5.5%
6	507	5.2%
2	486	5.0%
8	443	4.6%
1	358	3.7%
Other values (6)	949	9.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3593	12.9%
e	1874	6.7%
t	1680	6.0%
r	1633	5.9%
n	1386	5.0%
o	1322	4.7%
i	996	3.6%
a	984	3.5%
S	975	3.5%
l	930	3.3%
Other values (47)	12507	44.9%

ADDRESSLINE2
Text

Missing

Distinct	5
Distinct (%)	3.6%
Missing	2684
Missing (%)	95.1%
Memory size	22.2 KiB

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1251
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Suite 101
2nd row	Suite 750
3rd row	Suite 101
4th row	Suite 750
5th row	2nd Floor

Value	Count	Frequency (%)
suite	103	37.1%
400	48	17.3%
2nd	36	12.9%
floor	36	12.9%
101	25	9.0%
750	20	7.2%
200	10	3.6%

Most occurring characters

Value	Count	Frequency (%)
0	161	12.9%
	139	11.1%
u	103	8.2%
S	103	8.2%
t	103	8.2%
i	103	8.2%
e	103	8.2%
o	72	5.8%
1	50	4.0%
4	48	3.8%
Other values (8)	266	21.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	628	50.2%
Decimal Number	345	27.6%
Space Separator	139	11.1%
Uppercase Letter	139	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	103	16.4%
t	103	16.4%
i	103	16.4%
e	103	16.4%
o	72	11.5%
n	36	5.7%
d	36	5.7%
l	36	5.7%
r	36	5.7%

Decimal Number

Value	Count	Frequency (%)
0	161	46.7%
1	50	14.5%
4	48	13.9%
2	46	13.3%
7	20	5.8%
5	20	5.8%

Uppercase Letter

Value	Count	Frequency (%)
S	103	74.1%
F	36	25.9%

Space Separator

Value	Count	Frequency (%)
	139	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	767	61.3%
Common	484	38.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	103	13.4%
S	103	13.4%
t	103	13.4%
i	103	13.4%
e	103	13.4%
o	72	9.4%
n	36	4.7%
F	36	4.7%
d	36	4.7%
l	36	4.7%

Common

Value	Count	Frequency (%)
0	161	33.3%
	139	28.7%
1	50	10.3%
4	48	9.9%
2	46	9.5%
7	20	4.1%
5	20	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	161	12.9%
	139	11.1%
u	103	8.2%
S	103	8.2%
t	103	8.2%
i	103	8.2%
e	103	8.2%
o	72	5.8%
1	50	4.0%
4	48	3.8%
Other values (8)	266	21.3%

CITY
Text

Missing

Distinct	40
Distinct (%)	2.7%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	13
Median length	10
Mean length	8.167771883
Min length	3

Characters and Unicode

Total characters	12317
Distinct characters	45
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NYC
2nd row	Reims
3rd row	Paris
4th row	Pasadena
5th row	San Francisco

Value	Count	Frequency (%)
san	307	15.3%
rafael	180	8.9%
nyc	152	7.6%
new	78	3.9%
francisco	62	3.1%
bedford	61	3.0%
bergamo	48	2.4%
brickhaven	47	2.3%
boston	44	2.2%
reims	41	2.0%
Other values (36)	993	49.3%

Most occurring characters

Value	Count	Frequency (%)
a	1703	13.8%
e	1161	9.4%
n	889	7.2%
r	692	5.6%
o	666	5.4%
i	636	5.2%
l	563	4.6%
s	506	4.1%
	505	4.1%
S	415	3.4%
Other values (35)	4581	37.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9495	77.1%
Uppercase Letter	2317	18.8%
Space Separator	505	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1703	17.9%
e	1161	12.2%
n	889	9.4%
r	692	7.3%
o	666	7.0%
i	636	6.7%
l	563	5.9%
s	506	5.3%
g	353	3.7%
d	260	2.7%
Other values (14)	2066	21.8%

Uppercase Letter

Value	Count	Frequency (%)
S	415	17.9%
B	350	15.1%
N	285	12.3%
R	260	11.2%
C	242	10.4%
Y	152	6.6%
P	99	4.3%
F	62	2.7%
A	58	2.5%
V	51	2.2%
Other values (10)	343	14.8%

Space Separator

Value	Count	Frequency (%)
	505	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11812	95.9%
Common	505	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1703	14.4%
e	1161	9.8%
n	889	7.5%
r	692	5.9%
o	666	5.6%
i	636	5.4%
l	563	4.8%
s	506	4.3%
S	415	3.5%
g	353	3.0%
Other values (34)	4228	35.8%

Common

Value	Count	Frequency (%)
	505	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12317	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1703	13.8%
e	1161	9.4%
n	889	7.2%
r	692	5.6%
o	666	5.4%
i	636	5.2%
l	563	4.6%
s	506	4.1%
	505	4.1%
S	415	3.4%
Other values (35)	4581	37.2%

STATE
Text

Missing

Distinct	11
Distinct (%)	1.1%
Missing	1784
Missing (%)	63.2%
Memory size	22.2 KiB

Length

Max length	13
Median length	2
Mean length	2.359961501
Min length	2

Characters and Unicode

Total characters	2452
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NY
2nd row	CA
3rd row	CA
4th row	CA
5th row	CA

Value	Count	Frequency (%)
ca	402	36.8%
ma	190	17.4%
ny	178	16.3%
ct	61	5.6%
pa	54	4.9%
nh	34	3.1%
nv	29	2.7%
isle	26	2.4%
of	26	2.4%
wight	26	2.4%
Other values (3)	65	6.0%

Most occurring characters

Value	Count	Frequency (%)
A	646	26.3%
C	485	19.8%
N	262	10.7%
M	190	7.7%
Y	178	7.3%
e	70	2.9%
T	61	2.5%
P	54	2.2%
	52	2.1%
H	34	1.4%
Other values (17)	420	17.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2056	83.8%
Lowercase Letter	344	14.0%
Space Separator	52	2.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	646	31.4%
C	485	23.6%
N	262	12.7%
M	190	9.2%
Y	178	8.7%
T	61	3.0%
P	54	2.6%
H	34	1.7%
V	29	1.4%
I	26	1.3%
Other values (4)	91	4.4%

Lowercase Letter

Value	Count	Frequency (%)
e	70	20.3%
s	26	7.6%
l	26	7.6%
o	26	7.6%
f	26	7.6%
i	26	7.6%
g	26	7.6%
h	26	7.6%
t	26	7.6%
u	22	6.4%
Other values (2)	44	12.8%

Space Separator

Value	Count	Frequency (%)
	52	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2400	97.9%
Common	52	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	646	26.9%
C	485	20.2%
N	262	10.9%
M	190	7.9%
Y	178	7.4%
e	70	2.9%
T	61	2.5%
P	54	2.2%
H	34	1.4%
V	29	1.2%
Other values (16)	391	16.3%

Common

Value	Count	Frequency (%)
	52	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2452	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	646	26.3%
C	485	19.8%
N	262	10.7%
M	190	7.7%
Y	178	7.3%
e	70	2.9%
T	61	2.5%
P	54	2.2%
	52	2.1%
H	34	1.4%
Other values (17)	420	17.1%

POSTALCODE
Text

Missing

Distinct	36
Distinct (%)	2.5%
Missing	1377
Missing (%)	48.8%
Memory size	22.2 KiB

Length

Max length	8
Median length	5
Mean length	5.143153527
Min length	4

Characters and Unicode

Total characters	7437
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10022
2nd row	51100
3rd row	75508
4th row	90003
5th row	94217

Value	Count	Frequency (%)
97562	205	13.0%
10022	152	9.6%
94217	89	5.6%
50553	61	3.9%
24100	48	3.0%
58339	47	3.0%
51003	44	2.8%
51100	41	2.6%
5020	40	2.5%
42100	39	2.5%
Other values (31)	814	51.5%

Most occurring characters

Value	Count	Frequency (%)
0	1454	19.6%
2	1023	13.8%
1	976	13.1%
5	730	9.8%
7	673	9.0%
9	539	7.2%
4	454	6.1%
3	430	5.8%
6	392	5.3%
8	218	2.9%
Other values (13)	548	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6889	92.6%
Uppercase Letter	351	4.7%
Space Separator	134	1.8%
Dash Punctuation	63	0.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	52	14.8%
M	52	14.8%
J	48	13.7%
S	38	10.8%
O	26	7.4%
B	25	7.1%
H	22	6.3%
C	22	6.3%
V	22	6.3%
F	22	6.3%

Decimal Number

Value	Count	Frequency (%)
0	1454	21.1%
2	1023	14.8%
1	976	14.2%
5	730	10.6%
7	673	9.8%
9	539	7.8%
4	454	6.6%
3	430	6.2%
6	392	5.7%
8	218	3.2%

Space Separator

Value	Count	Frequency (%)
	134	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	63	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7086	95.3%
Latin	351	4.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1454	20.5%
2	1023	14.4%
1	976	13.8%
5	730	10.3%
7	673	9.5%
9	539	7.6%
4	454	6.4%
3	430	6.1%
6	392	5.5%
8	218	3.1%
Other values (2)	197	2.8%

Latin

Value	Count	Frequency (%)
P	52	14.8%
M	52	14.8%
J	48	13.7%
S	38	10.8%
O	26	7.4%
B	25	7.1%
H	22	6.3%
C	22	6.3%
V	22	6.3%
F	22	6.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7437	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1454	19.6%
2	1023	13.8%
1	976	13.1%
5	730	9.8%
7	673	9.0%
9	539	7.2%
4	454	6.1%
3	430	5.8%
6	392	5.3%
8	218	2.9%
Other values (13)	548	7.4%

COUNTRY
Text

Missing

Distinct	12
Distinct (%)	0.8%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	11
Median length	3
Mean length	4.181034483
Min length	2

Characters and Unicode

Total characters	6305
Distinct characters	30
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USA
2nd row	France
3rd row	France
4th row	USA
5th row	USA

Value	Count	Frequency (%)
usa	969	64.3%
italy	113	7.5%
france	81	5.4%
denmark	63	4.2%
austria	55	3.6%
canada	44	2.9%
sweden	38	2.5%
singapore	36	2.4%
norway	32	2.1%
uk	26	1.7%
Other values (2)	51	3.4%

Most occurring characters

Value	Count	Frequency (%)
S	1043	16.5%
A	1024	16.2%
U	995	15.8%
a	512	8.1%
e	307	4.9%
n	288	4.6%
r	267	4.2%
i	194	3.1%
t	168	2.7%
l	164	2.6%
Other values (20)	1343	21.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3472	55.1%
Lowercase Letter	2833	44.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	512	18.1%
e	307	10.8%
n	288	10.2%
r	267	9.4%
i	194	6.8%
t	168	5.9%
l	164	5.8%
y	145	5.1%
m	88	3.1%
p	88	3.1%
Other values (9)	612	21.6%

Uppercase Letter

Value	Count	Frequency (%)
S	1043	30.0%
A	1024	29.5%
U	995	28.7%
I	113	3.3%
F	81	2.3%
D	63	1.8%
C	44	1.3%
N	32	0.9%
K	26	0.7%
P	26	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6305	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	1043	16.5%
A	1024	16.2%
U	995	15.8%
a	512	8.1%
e	307	4.9%
n	288	4.6%
r	267	4.2%
i	194	3.1%
t	168	2.7%
l	164	2.6%
Other values (20)	1343	21.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6305	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	1043	16.5%
A	1024	16.2%
U	995	15.8%
a	512	8.1%
e	307	4.9%
n	288	4.6%
r	267	4.2%
i	194	3.1%
t	168	2.7%
l	164	2.6%
Other values (20)	1343	21.3%

TERRITORY
Text

Missing

Distinct	3
Distinct (%)	0.6%
Missing	2328
Missing (%)	82.5%
Memory size	22.2 KiB

Length

Max length	5
Median length	4
Mean length	4.052525253
Min length	4

Characters and Unicode

Total characters	2006
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EMEA
2nd row	EMEA
3rd row	EMEA
4th row	EMEA
5th row	EMEA

Value	Count	Frequency (%)
emea	433	87.5%
apac	36	7.3%
japan	26	5.3%

Most occurring characters

Value	Count	Frequency (%)
E	866	43.2%
A	505	25.2%
M	433	21.6%
a	52	2.6%
P	36	1.8%
C	36	1.8%
J	26	1.3%
p	26	1.3%
n	26	1.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1902	94.8%
Lowercase Letter	104	5.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	866	45.5%
A	505	26.6%
M	433	22.8%
P	36	1.9%
C	36	1.9%
J	26	1.4%

Lowercase Letter

Value	Count	Frequency (%)
a	52	50.0%
p	26	25.0%
n	26	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2006	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	866	43.2%
A	505	25.2%
M	433	21.6%
a	52	2.6%
P	36	1.8%
C	36	1.8%
J	26	1.3%
p	26	1.3%
n	26	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2006	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	866	43.2%
A	505	25.2%
M	433	21.6%
a	52	2.6%
P	36	1.8%
C	36	1.8%
J	26	1.3%
p	26	1.3%
n	26	1.3%

CONTACTLASTNAME
Text

Missing

Distinct	37
Distinct (%)	2.5%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	10
Median length	9
Mean length	6.00464191
Min length	2

Characters and Unicode

Total characters	9055
Distinct characters	41
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Yu
2nd row	Henriot
3rd row	Da Cunha
4th row	Young
5th row	Brown

Value	Count	Frequency (%)
nelson	204	13.4%
young	115	7.5%
frick	91	6.0%
yu	80	5.2%
hernandez	70	4.6%
brown	62	4.1%
king	54	3.5%
rovelli	48	3.1%
henriot	41	2.7%
pipps	40	2.6%
Other values (28)	723	47.3%

Most occurring characters

Value	Count	Frequency (%)
n	1104	12.2%
o	917	10.1%
e	910	10.0%
r	691	7.6%
s	568	6.3%
i	560	6.2%
l	390	4.3%
u	363	4.0%
a	347	3.8%
t	237	2.6%
Other values (31)	2968	32.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7507	82.9%
Uppercase Letter	1528	16.9%
Space Separator	20	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	1104	14.7%
o	917	12.2%
e	910	12.1%
r	691	9.2%
s	568	7.6%
i	560	7.5%
l	390	5.2%
u	363	4.8%
a	347	4.6%
t	237	3.2%
Other values (14)	1420	18.9%

Uppercase Letter

Value	Count	Frequency (%)
Y	221	14.5%
N	204	13.4%
B	161	10.5%
H	145	9.5%
F	131	8.6%
T	129	8.4%
M	92	6.0%
P	76	5.0%
R	68	4.5%
K	64	4.2%
Other values (6)	237	15.5%

Space Separator

Value	Count	Frequency (%)
	20	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9035	99.8%
Common	20	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	1104	12.2%
o	917	10.1%
e	910	10.1%
r	691	7.6%
s	568	6.3%
i	560	6.2%
l	390	4.3%
u	363	4.0%
a	347	3.8%
t	237	2.6%
Other values (30)	2948	32.6%

Common

Value	Count	Frequency (%)
	20	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9055	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	1104	12.2%
o	917	10.1%
e	910	10.0%
r	691	7.6%
s	568	6.3%
i	560	6.2%
l	390	4.3%
u	363	4.0%
a	347	3.8%
t	237	2.6%
Other values (31)	2968	32.8%

CONTACTFIRSTNAME
Text

Missing

Distinct	37
Distinct (%)	2.5%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	9
Median length	8
Mean length	5.483421751
Min length	3

Characters and Unicode

Total characters	8269
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Kwai
2nd row	Paul
3rd row	Daniel
4th row	Julie
5th row	Julie

Value	Count	Frequency (%)
valarie	257	16.7%
julie	117	7.6%
sue	84	5.4%
juri	60	3.9%
maria	58	3.8%
kwai	49	3.2%
jeff	48	3.1%
giovanni	48	3.1%
kyung	42	2.7%
paul	41	2.7%
Other values (28)	739	47.9%

Most occurring characters

Value	Count	Frequency (%)
a	1142	13.8%
e	1073	13.0%
i	953	11.5%
l	766	9.3%
r	532	6.4%
n	458	5.5%
u	398	4.8%
o	323	3.9%
J	315	3.8%
V	283	3.4%
Other values (26)	2026	24.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6691	80.9%
Uppercase Letter	1543	18.7%
Space Separator	35	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1142	17.1%
e	1073	16.0%
i	953	14.2%
l	766	11.4%
r	532	8.0%
n	458	6.8%
u	398	5.9%
o	323	4.8%
t	229	3.4%
g	132	2.0%
Other values (10)	685	10.2%

Uppercase Letter

Value	Count	Frequency (%)
J	315	20.4%
V	283	18.3%
M	164	10.6%
S	123	8.0%
K	101	6.5%
P	94	6.1%
W	92	6.0%
G	88	5.7%
A	70	4.5%
C	60	3.9%
Other values (5)	153	9.9%

Space Separator

Value	Count	Frequency (%)
	35	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8234	99.6%
Common	35	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1142	13.9%
e	1073	13.0%
i	953	11.6%
l	766	9.3%
r	532	6.5%
n	458	5.6%
u	398	4.8%
o	323	3.9%
J	315	3.8%
V	283	3.4%
Other values (25)	1991	24.2%

Common

Value	Count	Frequency (%)
	35	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8269	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1142	13.8%
e	1073	13.0%
i	953	11.5%
l	766	9.3%
r	532	6.4%
n	458	5.5%
u	398	4.8%
o	323	3.9%
J	315	3.8%
V	283	3.4%
Other values (26)	2026	24.5%

DEALSIZE
Text

Missing

Distinct	3
Distinct (%)	0.2%
Missing	1315
Missing (%)	46.6%
Memory size	22.2 KiB

Length

Max length	6
Median length	5
Mean length	5.49403183
Min length	5

Characters and Unicode

Total characters	8285
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Small
2nd row	Small
3rd row	Medium
4th row	Medium
5th row	Medium

Value	Count	Frequency (%)
medium	745	49.4%
small	673	44.6%
large	90	6.0%

Most occurring characters

Value	Count	Frequency (%)
m	1418	17.1%
l	1346	16.2%
e	835	10.1%
a	763	9.2%
i	745	9.0%
d	745	9.0%
M	745	9.0%
u	745	9.0%
S	673	8.1%
L	90	1.1%
Other values (2)	180	2.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6777	81.8%
Uppercase Letter	1508	18.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	1418	20.9%
l	1346	19.9%
e	835	12.3%
a	763	11.3%
i	745	11.0%
d	745	11.0%
u	745	11.0%
r	90	1.3%
g	90	1.3%

Uppercase Letter

Value	Count	Frequency (%)
M	745	49.4%
S	673	44.6%
L	90	6.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8285	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	1418	17.1%
l	1346	16.2%
e	835	10.1%
a	763	9.2%
i	745	9.0%
d	745	9.0%
M	745	9.0%
u	745	9.0%
S	673	8.1%
L	90	1.1%
Other values (2)	180	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8285	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
m	1418	17.1%
l	1346	16.2%
e	835	10.1%
a	763	9.2%
i	745	9.0%
d	745	9.0%
M	745	9.0%
u	745	9.0%
S	673	8.1%
L	90	1.1%
Other values (2)	180	2.2%

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Connector Punctuation

Dash Punctuation

Close Punctuation

Open Punctuation

Math Symbol

Currency Symbol

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Connector Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter